USE [master]
GO
/****** Object:  Database [JHY.Management]    Script Date: 2024/9/6 15:53:10 ******/
CREATE DATABASE [JHY.Management]
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [JHY.Management].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [JHY.Management] SET ANSI_NULL_DEFAULT OFF 
GO
ALTER DATABASE [JHY.Management] SET ANSI_NULLS OFF 
GO
ALTER DATABASE [JHY.Management] SET ANSI_PADDING OFF 
GO
ALTER DATABASE [JHY.Management] SET ANSI_WARNINGS OFF 
GO
ALTER DATABASE [JHY.Management] SET ARITHABORT OFF 
GO
ALTER DATABASE [JHY.Management] SET AUTO_CLOSE OFF 
GO
ALTER DATABASE [JHY.Management] SET AUTO_SHRINK OFF 
GO
ALTER DATABASE [JHY.Management] SET AUTO_UPDATE_STATISTICS ON 
GO
ALTER DATABASE [JHY.Management] SET CURSOR_CLOSE_ON_COMMIT OFF 
GO
ALTER DATABASE [JHY.Management] SET CURSOR_DEFAULT  GLOBAL 
GO
ALTER DATABASE [JHY.Management] SET CONCAT_NULL_YIELDS_NULL OFF 
GO
ALTER DATABASE [JHY.Management] SET NUMERIC_ROUNDABORT OFF 
GO
ALTER DATABASE [JHY.Management] SET QUOTED_IDENTIFIER OFF 
GO
ALTER DATABASE [JHY.Management] SET RECURSIVE_TRIGGERS OFF 
GO
ALTER DATABASE [JHY.Management] SET  DISABLE_BROKER 
GO
ALTER DATABASE [JHY.Management] SET AUTO_UPDATE_STATISTICS_ASYNC OFF 
GO
ALTER DATABASE [JHY.Management] SET DATE_CORRELATION_OPTIMIZATION OFF 
GO
ALTER DATABASE [JHY.Management] SET TRUSTWORTHY OFF 
GO
ALTER DATABASE [JHY.Management] SET ALLOW_SNAPSHOT_ISOLATION OFF 
GO
ALTER DATABASE [JHY.Management] SET PARAMETERIZATION SIMPLE 
GO
ALTER DATABASE [JHY.Management] SET READ_COMMITTED_SNAPSHOT OFF 
GO
ALTER DATABASE [JHY.Management] SET HONOR_BROKER_PRIORITY OFF 
GO
ALTER DATABASE [JHY.Management] SET RECOVERY FULL 
GO
ALTER DATABASE [JHY.Management] SET  MULTI_USER 
GO
ALTER DATABASE [JHY.Management] SET PAGE_VERIFY CHECKSUM  
GO
ALTER DATABASE [JHY.Management] SET DB_CHAINING OFF 
GO
ALTER DATABASE [JHY.Management] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF ) 
GO
ALTER DATABASE [JHY.Management] SET TARGET_RECOVERY_TIME = 60 SECONDS 
GO
EXEC sys.sp_db_vardecimal_storage_format N'JHY.Management', N'ON'
GO
USE [JHY.Management]
GO
/****** Object:  Table [dbo].[Sys_Button]    Script Date: 2024/9/6 15:53:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Sys_Button](
	[Id] [uniqueidentifier] NOT NULL,
	[ParentId] [uniqueidentifier] NOT NULL,
	[BtnText] [nvarchar](255) NOT NULL,
	[BtnValue] [nvarchar](255) NOT NULL,
	[Icon] [nvarchar](255) NULL,
	[Size] [nvarchar](255) NULL,
	[BackColor] [nvarchar](255) NULL,
	[Description] [nvarchar](255) NULL,
	[CreateTime] [datetime] NOT NULL,
	[ModifyTime] [datetime] NULL,
	[Status] [int] NOT NULL,
 CONSTRAINT [PK_Sys_Button_Id] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Sys_Menu]    Script Date: 2024/9/6 15:53:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Sys_Menu](
	[Id] [uniqueidentifier] NOT NULL,
	[ParentId] [uniqueidentifier] NOT NULL,
	[MenuText] [nvarchar](255) NOT NULL,
	[MenuType] [int] NOT NULL,
	[Icon] [nvarchar](255) NULL,
	[WebUrlName] [nvarchar](255) NULL,
	[WebUrl] [nvarchar](255) NULL,
	[VueFilePath] [nvarchar](255) NULL,
	[IsLeafNode] [bit] NOT NULL,
	[OrderBy] [int] NOT NULL,
	[CreateTime] [datetime] NOT NULL,
	[ModifyTime] [datetime] NULL,
	[Status] [int] NOT NULL,
 CONSTRAINT [PK_Sys_Menu_Id] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Sys_Role]    Script Date: 2024/9/6 15:53:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Sys_Role](
	[RoleId] [int] IDENTITY(1,1) NOT NULL,
	[RoleName] [nvarchar](255) NOT NULL,
	[Status] [int] NOT NULL,
	[CreateTime] [datetime] NOT NULL,
	[ModifyTime] [datetime] NULL,
 CONSTRAINT [PK_Sys_Role_RoleId] PRIMARY KEY CLUSTERED 
(
	[RoleId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Sys_RoleBtnMap]    Script Date: 2024/9/6 15:53:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Sys_RoleBtnMap](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[RoleId] [int] NOT NULL,
	[BtnId] [uniqueidentifier] NOT NULL,
	[CreateTime] [datetime] NOT NULL,
	[ModifyTime] [datetime] NULL,
	[Status] [int] NOT NULL,
 CONSTRAINT [PK_Sys_RoleBtnMap_Id] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Sys_RoleMenuMap]    Script Date: 2024/9/6 15:53:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Sys_RoleMenuMap](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[RoleId] [int] NOT NULL,
	[MenuId] [uniqueidentifier] NOT NULL,
	[CreateTime] [datetime] NOT NULL,
	[ModifyTime] [datetime] NULL,
	[Status] [int] NOT NULL,
 CONSTRAINT [PK_Sys_RoleMenuMap_Id] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Sys_User]    Script Date: 2024/9/6 15:53:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Sys_User](
	[UserId] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](255) NOT NULL,
	[Password] [nvarchar](255) NOT NULL,
	[UserType] [int] NULL,
	[Phone] [nvarchar](255) NULL,
	[Mobile] [nvarchar](255) NULL,
	[Address] [nvarchar](255) NULL,
	[Email] [nvarchar](255) NULL,
	[QQ] [nvarchar](255) NOT NULL,
	[WeChat] [nvarchar](255) NULL,
	[Sex] [int] NOT NULL,
	[Imageurl] [nvarchar](255) NULL,
	[LastLoginTime] [datetime] NOT NULL,
	[CreateTime] [datetime] NOT NULL,
	[ModifyTime] [datetime] NULL,
	[Status] [int] NOT NULL,
 CONSTRAINT [PK_Sys_User_UserId] PRIMARY KEY CLUSTERED 
(
	[UserId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Sys_UserBtnMap]    Script Date: 2024/9/6 15:53:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Sys_UserBtnMap](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[UserId] [int] NOT NULL,
	[BtnId] [uniqueidentifier] NOT NULL,
	[CreateTime] [datetime] NOT NULL,
	[ModifyTime] [datetime] NULL,
	[Status] [int] NOT NULL,
 CONSTRAINT [PK_Sys_UserBtnMap_Id] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Sys_UserMenuMap]    Script Date: 2024/9/6 15:53:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Sys_UserMenuMap](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[UserId] [int] NOT NULL,
	[MenuId] [uniqueidentifier] NOT NULL,
	[CreateTime] [datetime] NOT NULL,
	[ModifyTime] [datetime] NULL,
	[Status] [int] NOT NULL,
 CONSTRAINT [PK_Sys_UserMenuMap_Id] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Sys_UserRoleMap]    Script Date: 2024/9/6 15:53:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Sys_UserRoleMap](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[UserId] [int] NOT NULL,
	[RoleId] [int] NOT NULL,
	[CreateTime] [datetime] NOT NULL,
	[ModifyTime] [datetime] NULL,
	[Status] [int] NOT NULL,
 CONSTRAINT [PK_Sys_UserRoleMap_Id] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
INSERT [dbo].[Sys_Button] ([Id], [ParentId], [BtnText], [BtnValue], [Icon], [Size], [BackColor], [Description], [CreateTime], [ModifyTime], [Status]) VALUES (N'11dae8f4-23d8-4a39-aa76-07482e5b9b3d', N'2831cc51-9c40-448f-a82c-8fa71da0767a', N'修改按钮', N'menu-updatebtn', N'Edit', N'small', N'default', N'修改按钮', CAST(N'2024-09-06T12:11:31.120' AS DateTime), CAST(N'1900-01-01T00:00:00.000' AS DateTime), 1)
GO
INSERT [dbo].[Sys_Button] ([Id], [ParentId], [BtnText], [BtnValue], [Icon], [Size], [BackColor], [Description], [CreateTime], [ModifyTime], [Status]) VALUES (N'87b48cec-f9e5-4f4d-b072-080740b46b18', N'a88231ee-bd8a-4726-97c2-c4084a29bf84', N'删除', N'role-deleterole', N'DeleteFilled', N'small', N'danger', N'删除角色信息', CAST(N'2024-09-06T12:11:31.120' AS DateTime), CAST(N'1900-01-01T00:00:00.000' AS DateTime), 1)
GO
INSERT [dbo].[Sys_Button] ([Id], [ParentId], [BtnText], [BtnValue], [Icon], [Size], [BackColor], [Description], [CreateTime], [ModifyTime], [Status]) VALUES (N'13cfc3d2-aa07-40a9-b318-09093d7a4fa1', N'a88231ee-bd8a-4726-97c2-c4084a29bf84', N'设置菜单', N'role-setrolemenus', N'Switch', N'small', N'info', N'设置角色菜单', CAST(N'2024-09-06T12:11:31.120' AS DateTime), CAST(N'1900-01-01T00:00:00.000' AS DateTime), 1)
GO
INSERT [dbo].[Sys_Button] ([Id], [ParentId], [BtnText], [BtnValue], [Icon], [Size], [BackColor], [Description], [CreateTime], [ModifyTime], [Status]) VALUES (N'98849f8e-aa7f-435f-9ed3-0f1a937a0f6e', N'f4277822-bbf5-4807-9897-2ff6bc5ece07', N'解冻', N'user-normaluser', N'WarnTriangleFilled', N'small', N'success', N'解冻用户', CAST(N'2024-09-06T12:11:31.120' AS DateTime), CAST(N'1900-01-01T00:00:00.000' AS DateTime), 1)
GO
INSERT [dbo].[Sys_Button] ([Id], [ParentId], [BtnText], [BtnValue], [Icon], [Size], [BackColor], [Description], [CreateTime], [ModifyTime], [Status]) VALUES (N'4984f249-53ce-4e07-9654-14705f07c48e', N'f4277822-bbf5-4807-9897-2ff6bc5ece07', N'分配菜单', N'user-setusermenuandbtn', N'Tools', N'small', N'info', N'设置用户菜单', CAST(N'2024-09-06T12:11:31.120' AS DateTime), CAST(N'1900-01-01T00:00:00.000' AS DateTime), 1)
GO
INSERT [dbo].[Sys_Button] ([Id], [ParentId], [BtnText], [BtnValue], [Icon], [Size], [BackColor], [Description], [CreateTime], [ModifyTime], [Status]) VALUES (N'e5e3eb12-b184-490e-a2f0-2e3db9998cf8', N'a88231ee-bd8a-4726-97c2-c4084a29bf84', N'查询', N'role-getrolepage', N'Search', N'default', N'default', N'角色分页列表', CAST(N'2024-09-06T12:11:31.120' AS DateTime), CAST(N'1900-01-01T00:00:00.000' AS DateTime), 1)
GO
INSERT [dbo].[Sys_Button] ([Id], [ParentId], [BtnText], [BtnValue], [Icon], [Size], [BackColor], [Description], [CreateTime], [ModifyTime], [Status]) VALUES (N'bd97ed0c-9f63-4b39-8f3c-3d811f1d15df', N'f4277822-bbf5-4807-9897-2ff6bc5ece07', N'删除', N'user-deleteuser', N'DeleteFilled', N'small', N'danger', N'删除用户信息', CAST(N'2024-09-06T12:11:31.120' AS DateTime), CAST(N'1900-01-01T00:00:00.000' AS DateTime), 1)
GO
INSERT [dbo].[Sys_Button] ([Id], [ParentId], [BtnText], [BtnValue], [Icon], [Size], [BackColor], [Description], [CreateTime], [ModifyTime], [Status]) VALUES (N'3e8fe98a-667c-41f4-ac38-4db50ea43e9c', N'f4277822-bbf5-4807-9897-2ff6bc5ece07', N'查询', N'user-getuserpage', N'Search', N'default', N'primary', N'用户分页列表', CAST(N'2024-09-06T12:11:31.120' AS DateTime), CAST(N'1900-01-01T00:00:00.000' AS DateTime), 1)
GO
INSERT [dbo].[Sys_Button] ([Id], [ParentId], [BtnText], [BtnValue], [Icon], [Size], [BackColor], [Description], [CreateTime], [ModifyTime], [Status]) VALUES (N'deacf60e-2251-4bce-96b8-53a8e11f5567', N'2831cc51-9c40-448f-a82c-8fa71da0767a', N'查询', N'menu-getmenutreepage', N'Search', N'default', N'default', N'查询按钮', CAST(N'2024-09-06T12:11:31.120' AS DateTime), CAST(N'1900-01-01T00:00:00.000' AS DateTime), 1)
GO
INSERT [dbo].[Sys_Button] ([Id], [ParentId], [BtnText], [BtnValue], [Icon], [Size], [BackColor], [Description], [CreateTime], [ModifyTime], [Status]) VALUES (N'2313a9f1-b1d8-4a58-82a8-591d2467a9e0', N'f4277822-bbf5-4807-9897-2ff6bc5ece07', N'编辑', N'user-putuser', N'Edit', N'small', N'primary', N'修改用户信息', CAST(N'2024-09-06T12:11:31.120' AS DateTime), CAST(N'1900-01-01T00:00:00.000' AS DateTime), 1)
GO
INSERT [dbo].[Sys_Button] ([Id], [ParentId], [BtnText], [BtnValue], [Icon], [Size], [BackColor], [Description], [CreateTime], [ModifyTime], [Status]) VALUES (N'1dc2dac9-f3cc-4e45-b892-67f865aa1cb7', N'2831cc51-9c40-448f-a82c-8fa71da0767a', N'修改', N'menu-updatemenu', N'Edit', N'small', N'success', N'修改菜单', CAST(N'2024-09-06T12:11:31.120' AS DateTime), CAST(N'1900-01-01T00:00:00.000' AS DateTime), 1)
GO
INSERT [dbo].[Sys_Button] ([Id], [ParentId], [BtnText], [BtnValue], [Icon], [Size], [BackColor], [Description], [CreateTime], [ModifyTime], [Status]) VALUES (N'8d070f2b-63b0-45dc-b20a-6a5eb8087a14', N'f4277822-bbf5-4807-9897-2ff6bc5ece07', N'分配角色', N'user-setuserrole', N'Share', N'small', N'warning', N'设置用户角色', CAST(N'2024-09-06T12:11:31.120' AS DateTime), CAST(N'1900-01-01T00:00:00.000' AS DateTime), 1)
GO
INSERT [dbo].[Sys_Button] ([Id], [ParentId], [BtnText], [BtnValue], [Icon], [Size], [BackColor], [Description], [CreateTime], [ModifyTime], [Status]) VALUES (N'3ca08e9c-428f-4133-84e9-8871808f46dd', N'a88231ee-bd8a-4726-97c2-c4084a29bf84', N'新增', N'role-addrole', N'CirclePlusFilled', N'default', N'primary', N'新增角色信息', CAST(N'2024-09-06T12:11:31.120' AS DateTime), CAST(N'1900-01-01T00:00:00.000' AS DateTime), 1)
GO
INSERT [dbo].[Sys_Button] ([Id], [ParentId], [BtnText], [BtnValue], [Icon], [Size], [BackColor], [Description], [CreateTime], [ModifyTime], [Status]) VALUES (N'96b68bb5-18ea-49cd-9b1a-98ec77323eb2', N'2831cc51-9c40-448f-a82c-8fa71da0767a', N'新增', N'menu-addmenu', N'CirclePlusFilled', N'default', N'default', N'新增菜单', CAST(N'2024-09-06T12:11:31.120' AS DateTime), CAST(N'1900-01-01T00:00:00.000' AS DateTime), 1)
GO
INSERT [dbo].[Sys_Button] ([Id], [ParentId], [BtnText], [BtnValue], [Icon], [Size], [BackColor], [Description], [CreateTime], [ModifyTime], [Status]) VALUES (N'453373b6-c786-478c-aeda-a243c732c227', N'a88231ee-bd8a-4726-97c2-c4084a29bf84', N'批量分配角色', N'role-batchsetuserrole', N'Switch', N'small', N'success', N'批量分配用户角色', CAST(N'2024-09-06T12:11:31.120' AS DateTime), CAST(N'1900-01-01T00:00:00.000' AS DateTime), 1)
GO
INSERT [dbo].[Sys_Button] ([Id], [ParentId], [BtnText], [BtnValue], [Icon], [Size], [BackColor], [Description], [CreateTime], [ModifyTime], [Status]) VALUES (N'773d0448-9220-425e-bca0-c734232fda98', N'a88231ee-bd8a-4726-97c2-c4084a29bf84', N'修改角色信息', N'role-putrole', N'Edit', N'small', N'success', N'修改角色信息', CAST(N'2024-09-06T12:11:31.120' AS DateTime), CAST(N'1900-01-01T00:00:00.000' AS DateTime), 1)
GO
INSERT [dbo].[Sys_Button] ([Id], [ParentId], [BtnText], [BtnValue], [Icon], [Size], [BackColor], [Description], [CreateTime], [ModifyTime], [Status]) VALUES (N'be1c1f63-621e-4582-ac24-c8d1e3803a86', N'f4277822-bbf5-4807-9897-2ff6bc5ece07', N'冻结', N'user-frozenuser', N'Lock', N'small', N'warning', N'冻结用户', CAST(N'2024-09-06T12:11:31.120' AS DateTime), CAST(N'1900-01-01T00:00:00.000' AS DateTime), 1)
GO
INSERT [dbo].[Sys_Button] ([Id], [ParentId], [BtnText], [BtnValue], [Icon], [Size], [BackColor], [Description], [CreateTime], [ModifyTime], [Status]) VALUES (N'6651c69e-2a36-4e5e-8b56-cca8d6a617cb', N'2831cc51-9c40-448f-a82c-8fa71da0767a', N'删除', N'menu-deletemenu', N'DeleteFilled', N'small', N'danger', N'删除菜单', CAST(N'2024-09-06T12:11:31.120' AS DateTime), CAST(N'1900-01-01T00:00:00.000' AS DateTime), 1)
GO
INSERT [dbo].[Sys_Button] ([Id], [ParentId], [BtnText], [BtnValue], [Icon], [Size], [BackColor], [Description], [CreateTime], [ModifyTime], [Status]) VALUES (N'8893a9cb-81e0-43e7-bf4c-d63cce4dcdf3', N'f4277822-bbf5-4807-9897-2ff6bc5ece07', N'添加用户', N'user-adduser', N'CirclePlusFilled', N'default', N'default', N'添加用户', CAST(N'2024-09-06T12:11:31.120' AS DateTime), CAST(N'1900-01-01T00:00:00.000' AS DateTime), 1)
GO
INSERT [dbo].[Sys_Menu] ([Id], [ParentId], [MenuText], [MenuType], [Icon], [WebUrlName], [WebUrl], [VueFilePath], [IsLeafNode], [OrderBy], [CreateTime], [ModifyTime], [Status]) VALUES (N'f4277822-bbf5-4807-9897-2ff6bc5ece07', N'00000000-0000-0000-0000-000000000000', N'用户管理', 1, N'UserFilled', N'user', N'/user', N'../views/Home/user/info/index.vue', 1, 0, CAST(N'2024-09-06T12:11:31.000' AS DateTime), CAST(N'2024-09-06T12:15:54.457' AS DateTime), 1)
GO
INSERT [dbo].[Sys_Menu] ([Id], [ParentId], [MenuText], [MenuType], [Icon], [WebUrlName], [WebUrl], [VueFilePath], [IsLeafNode], [OrderBy], [CreateTime], [ModifyTime], [Status]) VALUES (N'2831cc51-9c40-448f-a82c-8fa71da0767a', N'00000000-0000-0000-0000-000000000000', N'菜单管理', 1, N'Menu', N'menu', N'/menu', N'../views/Home/menu/info/index.vue', 1, 1, CAST(N'2024-09-06T12:11:30.000' AS DateTime), CAST(N'2024-09-06T12:15:46.900' AS DateTime), 1)
GO
INSERT [dbo].[Sys_Menu] ([Id], [ParentId], [MenuText], [MenuType], [Icon], [WebUrlName], [WebUrl], [VueFilePath], [IsLeafNode], [OrderBy], [CreateTime], [ModifyTime], [Status]) VALUES (N'a88231ee-bd8a-4726-97c2-c4084a29bf84', N'00000000-0000-0000-0000-000000000000', N'角色管理', 1, N'Share', N'role', N'/role', N'../views/Home/role/info/index.vue', 1, 2, CAST(N'2024-09-06T12:11:31.000' AS DateTime), CAST(N'2024-09-06T12:16:09.920' AS DateTime), 1)
GO
SET IDENTITY_INSERT [dbo].[Sys_Role] ON 
GO
INSERT [dbo].[Sys_Role] ([RoleId], [RoleName], [Status], [CreateTime], [ModifyTime]) VALUES (1, N'校长', 1, CAST(N'2024-09-06T12:25:17.443' AS DateTime), CAST(N'1900-01-01T00:00:00.000' AS DateTime))
GO
SET IDENTITY_INSERT [dbo].[Sys_Role] OFF
GO
SET IDENTITY_INSERT [dbo].[Sys_RoleBtnMap] ON 
GO
INSERT [dbo].[Sys_RoleBtnMap] ([Id], [RoleId], [BtnId], [CreateTime], [ModifyTime], [Status]) VALUES (1, 1, N'98849f8e-aa7f-435f-9ed3-0f1a937a0f6e', CAST(N'2024-09-06T13:05:10.953' AS DateTime), CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0)
GO
INSERT [dbo].[Sys_RoleBtnMap] ([Id], [RoleId], [BtnId], [CreateTime], [ModifyTime], [Status]) VALUES (2, 1, N'4984f249-53ce-4e07-9654-14705f07c48e', CAST(N'2024-09-06T13:05:10.953' AS DateTime), CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0)
GO
INSERT [dbo].[Sys_RoleBtnMap] ([Id], [RoleId], [BtnId], [CreateTime], [ModifyTime], [Status]) VALUES (3, 1, N'bd97ed0c-9f63-4b39-8f3c-3d811f1d15df', CAST(N'2024-09-06T13:05:10.953' AS DateTime), CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0)
GO
INSERT [dbo].[Sys_RoleBtnMap] ([Id], [RoleId], [BtnId], [CreateTime], [ModifyTime], [Status]) VALUES (4, 1, N'3e8fe98a-667c-41f4-ac38-4db50ea43e9c', CAST(N'2024-09-06T13:05:10.953' AS DateTime), CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0)
GO
INSERT [dbo].[Sys_RoleBtnMap] ([Id], [RoleId], [BtnId], [CreateTime], [ModifyTime], [Status]) VALUES (5, 1, N'2313a9f1-b1d8-4a58-82a8-591d2467a9e0', CAST(N'2024-09-06T13:05:10.953' AS DateTime), CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0)
GO
INSERT [dbo].[Sys_RoleBtnMap] ([Id], [RoleId], [BtnId], [CreateTime], [ModifyTime], [Status]) VALUES (6, 1, N'8d070f2b-63b0-45dc-b20a-6a5eb8087a14', CAST(N'2024-09-06T13:05:10.953' AS DateTime), CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0)
GO
SET IDENTITY_INSERT [dbo].[Sys_RoleBtnMap] OFF
GO
SET IDENTITY_INSERT [dbo].[Sys_RoleMenuMap] ON 
GO
INSERT [dbo].[Sys_RoleMenuMap] ([Id], [RoleId], [MenuId], [CreateTime], [ModifyTime], [Status]) VALUES (1, 1, N'f4277822-bbf5-4807-9897-2ff6bc5ece07', CAST(N'2024-09-06T13:05:10.937' AS DateTime), CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0)
GO
SET IDENTITY_INSERT [dbo].[Sys_RoleMenuMap] OFF
GO
SET IDENTITY_INSERT [dbo].[Sys_User] ON 
GO
INSERT [dbo].[Sys_User] ([UserId], [Name], [Password], [UserType], [Phone], [Mobile], [Address], [Email], [QQ], [WeChat], [Sex], [Imageurl], [LastLoginTime], [CreateTime], [ModifyTime], [Status]) VALUES (1, N'zhaoxi-admin', N'e10adc3949ba59abbe56e057f20f883e', 1, NULL, NULL, NULL, NULL, N'1234567', NULL, 1, N'FileUpload\NoImg.jpg', CAST(N'2024-09-06T15:41:51.523' AS DateTime), CAST(N'2024-09-06T11:17:51.600' AS DateTime), CAST(N'1900-01-01T00:00:00.000' AS DateTime), 1)
GO
INSERT [dbo].[Sys_User] ([UserId], [Name], [Password], [UserType], [Phone], [Mobile], [Address], [Email], [QQ], [WeChat], [Sex], [Imageurl], [LastLoginTime], [CreateTime], [ModifyTime], [Status]) VALUES (2, N'richard', N'c4ca4238a0b923820dcc509a6f75849b', 2, N'18672713698', N'18672713698', N'18672713698@163.com', N'18672713698@163.com', N'18672713698', N'18672713698', 1, N'FileUpload\2024-09-06\20240906121902_f110133d-ad34-4cec-b272-c6381f6cafdf.png', CAST(N'1900-01-01T00:00:00.000' AS DateTime), CAST(N'2024-09-06T12:20:41.317' AS DateTime), CAST(N'2024-09-06T14:52:20.510' AS DateTime), 1)
GO
SET IDENTITY_INSERT [dbo].[Sys_User] OFF
GO
SET IDENTITY_INSERT [dbo].[Sys_UserBtnMap] ON 
GO
INSERT [dbo].[Sys_UserBtnMap] ([Id], [UserId], [BtnId], [CreateTime], [ModifyTime], [Status]) VALUES (96, 1, N'11dae8f4-23d8-4a39-aa76-07482e5b9b3d', CAST(N'2024-09-06T12:11:37.617' AS DateTime), CAST(N'2024-09-06T12:11:37.617' AS DateTime), 1)
GO
INSERT [dbo].[Sys_UserBtnMap] ([Id], [UserId], [BtnId], [CreateTime], [ModifyTime], [Status]) VALUES (97, 1, N'87b48cec-f9e5-4f4d-b072-080740b46b18', CAST(N'2024-09-06T12:11:37.617' AS DateTime), CAST(N'2024-09-06T12:11:37.617' AS DateTime), 1)
GO
INSERT [dbo].[Sys_UserBtnMap] ([Id], [UserId], [BtnId], [CreateTime], [ModifyTime], [Status]) VALUES (98, 1, N'13cfc3d2-aa07-40a9-b318-09093d7a4fa1', CAST(N'2024-09-06T12:11:37.617' AS DateTime), CAST(N'2024-09-06T12:11:37.617' AS DateTime), 1)
GO
INSERT [dbo].[Sys_UserBtnMap] ([Id], [UserId], [BtnId], [CreateTime], [ModifyTime], [Status]) VALUES (99, 1, N'98849f8e-aa7f-435f-9ed3-0f1a937a0f6e', CAST(N'2024-09-06T12:11:37.617' AS DateTime), CAST(N'2024-09-06T12:11:37.617' AS DateTime), 1)
GO
INSERT [dbo].[Sys_UserBtnMap] ([Id], [UserId], [BtnId], [CreateTime], [ModifyTime], [Status]) VALUES (100, 1, N'4984f249-53ce-4e07-9654-14705f07c48e', CAST(N'2024-09-06T12:11:37.617' AS DateTime), CAST(N'2024-09-06T12:11:37.617' AS DateTime), 1)
GO
INSERT [dbo].[Sys_UserBtnMap] ([Id], [UserId], [BtnId], [CreateTime], [ModifyTime], [Status]) VALUES (101, 1, N'e5e3eb12-b184-490e-a2f0-2e3db9998cf8', CAST(N'2024-09-06T12:11:37.617' AS DateTime), CAST(N'2024-09-06T12:11:37.617' AS DateTime), 1)
GO
INSERT [dbo].[Sys_UserBtnMap] ([Id], [UserId], [BtnId], [CreateTime], [ModifyTime], [Status]) VALUES (102, 1, N'bd97ed0c-9f63-4b39-8f3c-3d811f1d15df', CAST(N'2024-09-06T12:11:37.617' AS DateTime), CAST(N'2024-09-06T12:11:37.617' AS DateTime), 1)
GO
INSERT [dbo].[Sys_UserBtnMap] ([Id], [UserId], [BtnId], [CreateTime], [ModifyTime], [Status]) VALUES (103, 1, N'3e8fe98a-667c-41f4-ac38-4db50ea43e9c', CAST(N'2024-09-06T12:11:37.617' AS DateTime), CAST(N'2024-09-06T12:11:37.617' AS DateTime), 1)
GO
INSERT [dbo].[Sys_UserBtnMap] ([Id], [UserId], [BtnId], [CreateTime], [ModifyTime], [Status]) VALUES (104, 1, N'deacf60e-2251-4bce-96b8-53a8e11f5567', CAST(N'2024-09-06T12:11:37.617' AS DateTime), CAST(N'2024-09-06T12:11:37.617' AS DateTime), 1)
GO
INSERT [dbo].[Sys_UserBtnMap] ([Id], [UserId], [BtnId], [CreateTime], [ModifyTime], [Status]) VALUES (105, 1, N'2313a9f1-b1d8-4a58-82a8-591d2467a9e0', CAST(N'2024-09-06T12:11:37.617' AS DateTime), CAST(N'2024-09-06T12:11:37.617' AS DateTime), 1)
GO
INSERT [dbo].[Sys_UserBtnMap] ([Id], [UserId], [BtnId], [CreateTime], [ModifyTime], [Status]) VALUES (106, 1, N'1dc2dac9-f3cc-4e45-b892-67f865aa1cb7', CAST(N'2024-09-06T12:11:37.617' AS DateTime), CAST(N'2024-09-06T12:11:37.617' AS DateTime), 1)
GO
INSERT [dbo].[Sys_UserBtnMap] ([Id], [UserId], [BtnId], [CreateTime], [ModifyTime], [Status]) VALUES (107, 1, N'8d070f2b-63b0-45dc-b20a-6a5eb8087a14', CAST(N'2024-09-06T12:11:37.617' AS DateTime), CAST(N'2024-09-06T12:11:37.617' AS DateTime), 1)
GO
INSERT [dbo].[Sys_UserBtnMap] ([Id], [UserId], [BtnId], [CreateTime], [ModifyTime], [Status]) VALUES (108, 1, N'3ca08e9c-428f-4133-84e9-8871808f46dd', CAST(N'2024-09-06T12:11:37.617' AS DateTime), CAST(N'2024-09-06T12:11:37.617' AS DateTime), 1)
GO
INSERT [dbo].[Sys_UserBtnMap] ([Id], [UserId], [BtnId], [CreateTime], [ModifyTime], [Status]) VALUES (109, 1, N'96b68bb5-18ea-49cd-9b1a-98ec77323eb2', CAST(N'2024-09-06T12:11:37.617' AS DateTime), CAST(N'2024-09-06T12:11:37.617' AS DateTime), 1)
GO
INSERT [dbo].[Sys_UserBtnMap] ([Id], [UserId], [BtnId], [CreateTime], [ModifyTime], [Status]) VALUES (110, 1, N'453373b6-c786-478c-aeda-a243c732c227', CAST(N'2024-09-06T12:11:37.617' AS DateTime), CAST(N'2024-09-06T12:11:37.617' AS DateTime), 1)
GO
INSERT [dbo].[Sys_UserBtnMap] ([Id], [UserId], [BtnId], [CreateTime], [ModifyTime], [Status]) VALUES (111, 1, N'773d0448-9220-425e-bca0-c734232fda98', CAST(N'2024-09-06T12:11:37.617' AS DateTime), CAST(N'2024-09-06T12:11:37.617' AS DateTime), 1)
GO
INSERT [dbo].[Sys_UserBtnMap] ([Id], [UserId], [BtnId], [CreateTime], [ModifyTime], [Status]) VALUES (112, 1, N'be1c1f63-621e-4582-ac24-c8d1e3803a86', CAST(N'2024-09-06T12:11:37.617' AS DateTime), CAST(N'2024-09-06T12:11:37.617' AS DateTime), 1)
GO
INSERT [dbo].[Sys_UserBtnMap] ([Id], [UserId], [BtnId], [CreateTime], [ModifyTime], [Status]) VALUES (113, 1, N'6651c69e-2a36-4e5e-8b56-cca8d6a617cb', CAST(N'2024-09-06T12:11:37.617' AS DateTime), CAST(N'2024-09-06T12:11:37.617' AS DateTime), 1)
GO
INSERT [dbo].[Sys_UserBtnMap] ([Id], [UserId], [BtnId], [CreateTime], [ModifyTime], [Status]) VALUES (114, 1, N'8893a9cb-81e0-43e7-bf4c-d63cce4dcdf3', CAST(N'2024-09-06T12:11:37.617' AS DateTime), CAST(N'2024-09-06T12:11:37.617' AS DateTime), 1)
GO
SET IDENTITY_INSERT [dbo].[Sys_UserBtnMap] OFF
GO
SET IDENTITY_INSERT [dbo].[Sys_UserMenuMap] ON 
GO
INSERT [dbo].[Sys_UserMenuMap] ([Id], [UserId], [MenuId], [CreateTime], [ModifyTime], [Status]) VALUES (16, 1, N'f4277822-bbf5-4807-9897-2ff6bc5ece07', CAST(N'2024-09-06T12:11:37.610' AS DateTime), CAST(N'2024-09-06T12:11:37.610' AS DateTime), 1)
GO
INSERT [dbo].[Sys_UserMenuMap] ([Id], [UserId], [MenuId], [CreateTime], [ModifyTime], [Status]) VALUES (17, 1, N'2831cc51-9c40-448f-a82c-8fa71da0767a', CAST(N'2024-09-06T12:11:37.610' AS DateTime), CAST(N'2024-09-06T12:11:37.610' AS DateTime), 1)
GO
INSERT [dbo].[Sys_UserMenuMap] ([Id], [UserId], [MenuId], [CreateTime], [ModifyTime], [Status]) VALUES (18, 1, N'a88231ee-bd8a-4726-97c2-c4084a29bf84', CAST(N'2024-09-06T12:11:37.610' AS DateTime), CAST(N'2024-09-06T12:11:37.610' AS DateTime), 1)
GO
SET IDENTITY_INSERT [dbo].[Sys_UserMenuMap] OFF
GO
SET IDENTITY_INSERT [dbo].[Sys_UserRoleMap] ON 
GO
INSERT [dbo].[Sys_UserRoleMap] ([Id], [UserId], [RoleId], [CreateTime], [ModifyTime], [Status]) VALUES (1, 2, 1, CAST(N'2024-09-06T14:08:49.627' AS DateTime), CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0)
GO
SET IDENTITY_INSERT [dbo].[Sys_UserRoleMap] OFF
GO
USE [master]
GO
ALTER DATABASE [JHY.Management] SET  READ_WRITE 
GO
